Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 450000 |
| Missing cells | 1816686 |
| Missing cells (%) | 20.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 68.7 MiB |
| Average record size in memory | 160.0 B |
Variable types
| Categorical | 11 |
|---|---|
| Numeric | 9 |
reassigned_order has constant value "1.0" | Constant |
order_time has a high cardinality: 252868 distinct values | High cardinality |
allot_time has a high cardinality: 246871 distinct values | High cardinality |
accept_time has a high cardinality: 254201 distinct values | High cardinality |
pickup_time has a high cardinality: 257117 distinct values | High cardinality |
delivered_time has a high cardinality: 257067 distinct values | High cardinality |
cancelled_time has a high cardinality: 5176 distinct values | High cardinality |
alloted_orders is highly correlated with delivered_orders and 1 other fields | High correlation |
delivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
lifetime_order_count is highly correlated with alloted_orders and 1 other fields | High correlation |
alloted_orders is highly correlated with delivered_orders | High correlation |
delivered_orders is highly correlated with alloted_orders | High correlation |
alloted_orders is highly correlated with delivered_orders | High correlation |
delivered_orders is highly correlated with alloted_orders | High correlation |
cancelled is highly correlated with reassigned_order | High correlation |
reassignment_reason is highly correlated with reassigned_order | High correlation |
order_date is highly correlated with reassigned_order | High correlation |
reassigned_order is highly correlated with cancelled and 3 other fields | High correlation |
reassignment_method is highly correlated with reassigned_order | High correlation |
order_id is highly correlated with order_date | High correlation |
order_date is highly correlated with order_id | High correlation |
alloted_orders is highly correlated with delivered_orders and 1 other fields | High correlation |
delivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
undelivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
delivered_time has 5218 (1.2%) missing values | Missing |
alloted_orders has 16948 (3.8%) missing values | Missing |
delivered_orders has 17341 (3.9%) missing values | Missing |
undelivered_orders has 17341 (3.9%) missing values | Missing |
reassignment_method has 436256 (96.9%) missing values | Missing |
reassignment_reason has 436247 (96.9%) missing values | Missing |
reassigned_order has 436247 (96.9%) missing values | Missing |
cancelled_time has 444782 (98.8%) missing values | Missing |
order_time is uniformly distributed | Uniform |
allot_time is uniformly distributed | Uniform |
accept_time is uniformly distributed | Uniform |
pickup_time is uniformly distributed | Uniform |
delivered_time is uniformly distributed | Uniform |
cancelled_time is uniformly distributed | Uniform |
undelivered_orders has 232686 (51.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-02-13 05:37:34.729919 |
|---|---|
| Analysis finished | 2022-02-13 05:39:21.262105 |
| Duration | 1 minute and 46.53 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 252868 |
|---|---|
| Distinct (%) | 56.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 2021-01-30 14:38:36 | 11 |
|---|---|
| 2021-01-30 13:30:43 | 11 |
| 2021-01-26 13:57:44 | 10 |
| 2021-01-30 13:33:54 | 10 |
| 2021-02-03 14:11:49 | 10 |
| Other values (252863) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 133840 ? |
|---|---|
| Unique (%) | 29.7% |
Sample
| 1st row | 2021-01-26 02:21:35 |
|---|---|
| 2nd row | 2021-01-26 02:33:16 |
| 3rd row | 2021-01-26 02:39:49 |
| 4th row | 2021-01-26 02:47:53 |
| 5th row | 2021-01-26 03:06:30 |
Common Values
| Value | Count | Frequency (%) |
| 2021-01-30 14:38:36 | 11 | < 0.1% |
| 2021-01-30 13:30:43 | 11 | < 0.1% |
| 2021-01-26 13:57:44 | 10 | < 0.1% |
| 2021-01-30 13:33:54 | 10 | < 0.1% |
| 2021-02-03 14:11:49 | 10 | < 0.1% |
| 2021-02-03 13:42:55 | 10 | < 0.1% |
| 2021-01-30 13:33:37 | 10 | < 0.1% |
| 2021-02-02 13:35:14 | 10 | < 0.1% |
| 2021-01-28 15:43:05 | 10 | < 0.1% |
| 2021-01-29 14:30:32 | 10 | < 0.1% |
| Other values (252858) | 449898 |
Length
| Value | Count | Frequency (%) |
| 2021-02-05 | 42341 | 4.7% |
| 2021-02-03 | 41447 | 4.6% |
| 2021-01-29 | 41207 | 4.6% |
| 2021-02-02 | 40875 | 4.5% |
| 2021-01-28 | 40783 | 4.5% |
| 2021-02-04 | 39685 | 4.4% |
| 2021-01-31 | 39254 | 4.4% |
| 2021-01-27 | 39015 | 4.3% |
| 2021-01-26 | 38090 | 4.2% |
| 2021-02-01 | 37833 | 4.2% |
| Other values (43385) | 499470 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 449999 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 369143.0808 |
| Minimum | 118350 |
|---|---|
| Maximum | 594842 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 118350 |
|---|---|
| 5-th percentile | 167343.95 |
| Q1 | 257342.75 |
| median | 369842.5 |
| Q3 | 482342.25 |
| 95-th percentile | 572342.05 |
| Maximum | 594842 |
| Range | 476492 |
| Interquartile range (IQR) | 224999.5 |
Descriptive statistics
| Standard deviation | 131146.9064 |
|---|---|
| Coefficient of variation (CV) | 0.355273912 |
| Kurtosis | -1.149146297 |
| Mean | 369143.0808 |
| Median Absolute Deviation (MAD) | 112500 |
| Skewness | -0.03426737717 |
| Sum | 1.661143863 × 1011 |
| Variance | 1.719951106 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 181402 | 2 | < 0.1% |
| 556753 | 1 | < 0.1% |
| 306422 | 1 | < 0.1% |
| 306433 | 1 | < 0.1% |
| 306430 | 1 | < 0.1% |
| 306429 | 1 | < 0.1% |
| 306428 | 1 | < 0.1% |
| 306431 | 1 | < 0.1% |
| 306432 | 1 | < 0.1% |
| 306427 | 1 | < 0.1% |
| Other values (449989) | 449989 |
| Value | Count | Frequency (%) |
| 118350 | 1 | |
| 118351 | 1 | |
| 118352 | 1 | |
| 118353 | 1 | |
| 118354 | 1 | |
| 118355 | 1 | |
| 118356 | 1 | |
| 118357 | 1 | |
| 118358 | 1 | |
| 118359 | 1 |
| Value | Count | Frequency (%) |
| 594842 | 1 | |
| 594841 | 1 | |
| 594840 | 1 | |
| 594839 | 1 | |
| 594838 | 1 | |
| 594837 | 1 | |
| 594836 | 1 | |
| 594835 | 1 | |
| 594834 | 1 | |
| 594833 | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 2021-02-05 00:00:00 | |
|---|---|
| 2021-02-03 00:00:00 | |
| 2021-01-29 00:00:00 | |
| 2021-02-02 00:00:00 | |
| 2021-01-28 00:00:00 | |
| Other values (7) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2021-01-26 00:00:00 |
|---|---|
| 2nd row | 2021-01-26 00:00:00 |
| 3rd row | 2021-01-26 00:00:00 |
| 4th row | 2021-01-26 00:00:00 |
| 5th row | 2021-01-26 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2021-02-05 00:00:00 | 42341 | |
| 2021-02-03 00:00:00 | 41447 | |
| 2021-01-29 00:00:00 | 41207 | |
| 2021-02-02 00:00:00 | 40875 | |
| 2021-01-28 00:00:00 | 40783 | |
| 2021-02-04 00:00:00 | 39685 | |
| 2021-01-31 00:00:00 | 39254 | |
| 2021-01-27 00:00:00 | 39015 | |
| 2021-01-26 00:00:00 | 38090 | |
| 2021-02-01 00:00:00 | 37833 | |
| Other values (2) | 49470 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 450000 | |
| 2021-02-05 | 42341 | 4.7% |
| 2021-02-03 | 41447 | 4.6% |
| 2021-01-29 | 41207 | 4.6% |
| 2021-02-02 | 40875 | 4.5% |
| 2021-01-28 | 40783 | 4.5% |
| 2021-02-04 | 39685 | 4.4% |
| 2021-01-31 | 39254 | 4.4% |
| 2021-01-27 | 39015 | 4.3% |
| 2021-01-26 | 38090 | 4.2% |
| Other values (3) | 87303 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 246871 |
|---|---|
| Distinct (%) | 54.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 2021-01-29 14:18:11 | 13 |
|---|---|
| 2021-02-03 14:56:54 | 13 |
| 2021-01-29 17:12:47 | 12 |
| 2021-01-29 16:19:15 | 12 |
| 2021-01-30 13:33:29 | 12 |
| Other values (246866) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 129910 ? |
|---|---|
| Unique (%) | 28.9% |
Sample
| 1st row | 2021-01-26 02:21:59 |
|---|---|
| 2nd row | 2021-01-26 02:33:57 |
| 3rd row | 2021-01-26 02:39:57 |
| 4th row | 2021-01-26 02:48:25 |
| 5th row | 2021-01-26 03:07:21 |
Common Values
| Value | Count | Frequency (%) |
| 2021-01-29 14:18:11 | 13 | < 0.1% |
| 2021-02-03 14:56:54 | 13 | < 0.1% |
| 2021-01-29 17:12:47 | 12 | < 0.1% |
| 2021-01-29 16:19:15 | 12 | < 0.1% |
| 2021-01-30 13:33:29 | 12 | < 0.1% |
| 2021-02-01 15:30:46 | 12 | < 0.1% |
| 2021-02-05 16:01:45 | 11 | < 0.1% |
| 2021-02-04 17:16:55 | 11 | < 0.1% |
| 2021-01-29 13:43:12 | 11 | < 0.1% |
| 2021-01-30 14:07:23 | 10 | < 0.1% |
| Other values (246861) | 449883 |
Length
| Value | Count | Frequency (%) |
| 2021-02-05 | 42341 | 4.7% |
| 2021-02-03 | 41447 | 4.6% |
| 2021-01-29 | 41207 | 4.6% |
| 2021-02-02 | 40875 | 4.5% |
| 2021-01-28 | 40783 | 4.5% |
| 2021-02-04 | 39685 | 4.4% |
| 2021-01-31 | 39254 | 4.4% |
| 2021-01-27 | 39015 | 4.3% |
| 2021-01-26 | 38090 | 4.2% |
| 2021-02-01 | 37833 | 4.2% |
| Other values (43527) | 499470 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 254201 |
|---|---|
| Distinct (%) | 56.5% |
| Missing | 157 |
| Missing (%) | < 0.1% |
| Memory size | 3.4 MiB |
| 2021-01-27 16:03:12 | 15 |
|---|---|
| 2021-02-01 13:32:55 | 13 |
| 2021-01-31 13:31:30 | 12 |
| 2021-01-29 13:35:13 | 11 |
| 2021-01-28 13:34:46 | 11 |
| Other values (254196) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 135348 ? |
|---|---|
| Unique (%) | 30.1% |
Sample
| 1st row | 2021-01-26 02:22:08 |
|---|---|
| 2nd row | 2021-01-26 02:34:45 |
| 3rd row | 2021-01-26 02:40:13 |
| 4th row | 2021-01-26 02:49:06 |
| 5th row | 2021-01-26 03:07:57 |
Common Values
| Value | Count | Frequency (%) |
| 2021-01-27 16:03:12 | 15 | < 0.1% |
| 2021-02-01 13:32:55 | 13 | < 0.1% |
| 2021-01-31 13:31:30 | 12 | < 0.1% |
| 2021-01-29 13:35:13 | 11 | < 0.1% |
| 2021-01-28 13:34:46 | 11 | < 0.1% |
| 2021-02-05 16:31:47 | 10 | < 0.1% |
| 2021-01-31 17:03:36 | 10 | < 0.1% |
| 2021-02-01 15:33:34 | 10 | < 0.1% |
| 2021-02-05 14:47:12 | 10 | < 0.1% |
| 2021-01-28 14:24:33 | 10 | < 0.1% |
| Other values (254191) | 449731 | |
| (Missing) | 157 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| 2021-02-05 | 42325 | 4.7% |
| 2021-02-03 | 41436 | 4.6% |
| 2021-01-29 | 41192 | 4.6% |
| 2021-02-02 | 40864 | 4.5% |
| 2021-01-28 | 40775 | 4.5% |
| 2021-02-04 | 39673 | 4.4% |
| 2021-01-31 | 39236 | 4.4% |
| 2021-01-27 | 39006 | 4.3% |
| 2021-01-26 | 38076 | 4.2% |
| 2021-02-01 | 37815 | 4.2% |
| Other values (43911) | 499288 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 257117 |
|---|---|
| Distinct (%) | 57.4% |
| Missing | 2421 |
| Missing (%) | 0.5% |
| Memory size | 3.4 MiB |
| 2021-01-28 15:29:58 | 11 |
|---|---|
| 2021-01-30 14:12:40 | 10 |
| 2021-01-28 15:52:01 | 10 |
| 2021-01-29 14:50:58 | 10 |
| 2021-02-05 15:06:01 | 10 |
| Other values (257112) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 139375 ? |
|---|---|
| Unique (%) | 31.1% |
Sample
| 1st row | 2021-01-26 02:32:51 |
|---|---|
| 2nd row | 2021-01-26 02:50:25 |
| 3rd row | 2021-01-26 02:56:00 |
| 4th row | 2021-01-26 03:21:51 |
| 5th row | 2021-01-26 03:31:38 |
Common Values
| Value | Count | Frequency (%) |
| 2021-01-28 15:29:58 | 11 | < 0.1% |
| 2021-01-30 14:12:40 | 10 | < 0.1% |
| 2021-01-28 15:52:01 | 10 | < 0.1% |
| 2021-01-29 14:50:58 | 10 | < 0.1% |
| 2021-02-05 15:06:01 | 10 | < 0.1% |
| 2021-01-30 15:22:40 | 10 | < 0.1% |
| 2021-02-02 16:14:37 | 10 | < 0.1% |
| 2021-01-30 15:22:11 | 10 | < 0.1% |
| 2021-02-02 14:19:50 | 10 | < 0.1% |
| 2021-02-05 14:51:14 | 9 | < 0.1% |
| Other values (257107) | 447479 | |
| (Missing) | 2421 | 0.5% |
Length
| Value | Count | Frequency (%) |
| 2021-02-05 | 42117 | 4.7% |
| 2021-02-03 | 41247 | 4.6% |
| 2021-01-29 | 41010 | 4.6% |
| 2021-02-02 | 40674 | 4.5% |
| 2021-01-28 | 40585 | 4.5% |
| 2021-02-04 | 39511 | 4.4% |
| 2021-01-31 | 39065 | 4.4% |
| 2021-01-27 | 38824 | 4.3% |
| 2021-01-26 | 37883 | 4.2% |
| 2021-02-01 | 37667 | 4.2% |
| Other values (44674) | 496575 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 257067 |
|---|---|
| Distinct (%) | 57.8% |
| Missing | 5218 |
| Missing (%) | 1.2% |
| Memory size | 3.4 MiB |
| 2021-01-30 14:38:14 | 12 |
|---|---|
| 2021-02-01 16:27:22 | 9 |
| 2021-01-31 15:45:09 | 9 |
| 2021-02-01 15:54:50 | 9 |
| 2021-01-29 14:26:56 | 9 |
| Other values (257062) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 140784 ? |
|---|---|
| Unique (%) | 31.7% |
Sample
| 1st row | 2021-01-26 02:49:47 |
|---|---|
| 2nd row | 2021-01-26 03:11:15 |
| 3rd row | 2021-01-26 03:12:46 |
| 4th row | 2021-01-26 03:41:05 |
| 5th row | 2021-01-26 04:00:15 |
Common Values
| Value | Count | Frequency (%) |
| 2021-01-30 14:38:14 | 12 | < 0.1% |
| 2021-02-01 16:27:22 | 9 | < 0.1% |
| 2021-01-31 15:45:09 | 9 | < 0.1% |
| 2021-02-01 15:54:50 | 9 | < 0.1% |
| 2021-01-29 14:26:56 | 9 | < 0.1% |
| 2021-01-30 14:38:18 | 9 | < 0.1% |
| 2021-02-05 15:53:02 | 9 | < 0.1% |
| 2021-01-27 14:25:53 | 9 | < 0.1% |
| 2021-01-28 16:38:24 | 9 | < 0.1% |
| 2021-02-03 15:41:30 | 9 | < 0.1% |
| Other values (257057) | 444689 | |
| (Missing) | 5218 | 1.2% |
Length
| Value | Count | Frequency (%) |
| 2021-02-05 | 41842 | 4.7% |
| 2021-02-03 | 40985 | 4.6% |
| 2021-01-29 | 40754 | 4.6% |
| 2021-02-02 | 40461 | 4.5% |
| 2021-01-28 | 40292 | 4.5% |
| 2021-02-04 | 39262 | 4.4% |
| 2021-01-31 | 38899 | 4.4% |
| 2021-01-27 | 38609 | 4.3% |
| 2021-01-26 | 37628 | 4.2% |
| 2021-02-01 | 37450 | 4.2% |
| Other values (45275) | 493382 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
rider_id
Real number (ℝ≥0)
| Distinct | 19537 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7763.244016 |
| Minimum | 0 |
|---|---|
| Maximum | 21566 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 519 |
| Q1 | 2805 |
| median | 6754 |
| Q3 | 11965 |
| 95-th percentile | 18050 |
| Maximum | 21566 |
| Range | 21566 |
| Interquartile range (IQR) | 9160 |
Descriptive statistics
| Standard deviation | 5592.880135 |
|---|---|
| Coefficient of variation (CV) | 0.7204308049 |
| Kurtosis | -0.8427443266 |
| Mean | 7763.244016 |
| Median Absolute Deviation (MAD) | 4436 |
| Skewness | 0.4790871039 |
| Sum | 3493459807 |
| Variance | 31280308.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 237 | 228 | 0.1% |
| 190 | 213 | < 0.1% |
| 11998 | 209 | < 0.1% |
| 170 | 203 | < 0.1% |
| 853 | 200 | < 0.1% |
| 747 | 199 | < 0.1% |
| 2280 | 195 | < 0.1% |
| 4921 | 194 | < 0.1% |
| 12709 | 191 | < 0.1% |
| 453 | 190 | < 0.1% |
| Other values (19527) | 447978 |
| Value | Count | Frequency (%) |
| 0 | 7 | < 0.1% |
| 1 | 16 | < 0.1% |
| 2 | 28 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 15 | < 0.1% |
| 9 | 29 | < 0.1% |
| 10 | 97 | |
| 11 | 25 | < 0.1% |
| 12 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 21566 | 1 | |
| 21565 | 1 | |
| 21564 | 1 | |
| 21563 | 1 | |
| 21562 | 1 | |
| 21561 | 1 | |
| 21560 | 2 | |
| 21559 | 2 | |
| 21558 | 2 | |
| 21557 | 1 |
first_mile_distance
Real number (ℝ≥0)
| Distinct | 93743 |
|---|---|
| Distinct (%) | 20.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.229888977 |
| Minimum | 0.0001342587859 |
|---|---|
| Maximum | 42.0381 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0.0001342587859 |
|---|---|
| 5-th percentile | 0.05458151785 |
| Q1 | 0.539575 |
| median | 1.1387 |
| Q3 | 1.853 |
| 95-th percentile | 2.7079 |
| Maximum | 42.0381 |
| Range | 42.03796574 |
| Interquartile range (IQR) | 1.313425 |
Descriptive statistics
| Standard deviation | 0.8461826096 |
|---|---|
| Coefficient of variation (CV) | 0.688015443 |
| Kurtosis | 12.36678626 |
| Mean | 1.229888977 |
| Median Absolute Deviation (MAD) | 0.6482 |
| Skewness | 0.7588916893 |
| Sum | 553450.0398 |
| Variance | 0.7160250088 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.7153 | 39 | < 0.1% |
| 0.7404 | 39 | < 0.1% |
| 0.6965 | 36 | < 0.1% |
| 0.6959 | 36 | < 0.1% |
| 0.7241 | 34 | < 0.1% |
| 0.6578 | 34 | < 0.1% |
| 0.6883 | 34 | < 0.1% |
| 1.0009 | 34 | < 0.1% |
| 1.5356 | 34 | < 0.1% |
| 0.6174 | 34 | < 0.1% |
| Other values (93733) | 449646 |
| Value | Count | Frequency (%) |
| 0.0001342587859 | 2 | < 0.1% |
| 0.0002122817797 | 1 | < 0.1% |
| 0.0002848058939 | 1 | < 0.1% |
| 0.000328865519 | 1 | < 0.1% |
| 0.0003797411919 | 2 | < 0.1% |
| 0.0004027763578 | 5 | |
| 0.00041381337 | 1 | < 0.1% |
| 0.0004452860177 | 2 | < 0.1% |
| 0.0004552936947 | 3 | |
| 0.0004650860772 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.0381 | 1 | |
| 17.3442 | 1 | |
| 11.6741 | 1 | |
| 11.3649 | 1 | |
| 10.7525 | 1 | |
| 10.6994 | 1 | |
| 10.5839 | 1 | |
| 10.0546 | 1 | |
| 9.6695 | 1 | |
| 9.6079 | 1 |
last_mile_distance
Real number (ℝ≥0)
| Distinct | 1331 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.968872711 |
| Minimum | 0 |
|---|---|
| Maximum | 22.41 |
| Zeros | 94 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 1.47 |
| median | 2.67 |
| Q3 | 4.22 |
| 95-th percentile | 6.22 |
| Maximum | 22.41 |
| Range | 22.41 |
| Interquartile range (IQR) | 2.75 |
Descriptive statistics
| Standard deviation | 1.884123753 |
|---|---|
| Coefficient of variation (CV) | 0.6346259797 |
| Kurtosis | 0.8795462088 |
| Mean | 2.968872711 |
| Median Absolute Deviation (MAD) | 1.33 |
| Skewness | 0.8267706027 |
| Sum | 1335992.72 |
| Variance | 3.549922316 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.58 | 1143 | 0.3% |
| 1.5 | 1121 | 0.2% |
| 1.97 | 1119 | 0.2% |
| 1.45 | 1111 | 0.2% |
| 1.63 | 1110 | 0.2% |
| 1.46 | 1109 | 0.2% |
| 1.54 | 1107 | 0.2% |
| 1.32 | 1105 | 0.2% |
| 1.76 | 1104 | 0.2% |
| 1.67 | 1104 | 0.2% |
| Other values (1321) | 438867 |
| Value | Count | Frequency (%) |
| 0 | 94 | < 0.1% |
| 0.01 | 170 | < 0.1% |
| 0.02 | 210 | |
| 0.03 | 193 | |
| 0.04 | 237 | |
| 0.05 | 253 | |
| 0.06 | 291 | |
| 0.07 | 353 | |
| 0.08 | 415 | |
| 0.09 | 482 |
| Value | Count | Frequency (%) |
| 22.41 | 1 | |
| 22.26 | 1 | |
| 21.27 | 1 | |
| 21.21 | 1 | |
| 21.2 | 1 | |
| 21.12 | 1 | |
| 19.81 | 1 | |
| 18.13 | 1 | |
| 17.27 | 1 | |
| 16.85 | 1 |
alloted_orders
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 510 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 16948 |
| Missing (%) | 3.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104.6209093 |
| Minimum | 1 |
|---|---|
| Maximum | 567 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 36 |
| median | 81 |
| Q3 | 147 |
| 95-th percentile | 289 |
| Maximum | 567 |
| Range | 566 |
| Interquartile range (IQR) | 111 |
Descriptive statistics
| Standard deviation | 90.13549192 |
|---|---|
| Coefficient of variation (CV) | 0.8615437636 |
| Kurtosis | 2.098562998 |
| Mean | 104.6209093 |
| Median Absolute Deviation (MAD) | 52 |
| Skewness | 1.384162248 |
| Sum | 45306294 |
| Variance | 8124.406904 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 3764 | 0.8% |
| 5 | 3717 | 0.8% |
| 4 | 3648 | 0.8% |
| 2 | 3589 | 0.8% |
| 7 | 3586 | 0.8% |
| 3 | 3513 | 0.8% |
| 10 | 3424 | 0.8% |
| 8 | 3309 | 0.7% |
| 9 | 3168 | 0.7% |
| 12 | 3132 | 0.7% |
| Other values (500) | 398202 | |
| (Missing) | 16948 | 3.8% |
| Value | Count | Frequency (%) |
| 1 | 2991 | |
| 2 | 3589 | |
| 3 | 3513 | |
| 4 | 3648 | |
| 5 | 3717 | |
| 6 | 3764 | |
| 7 | 3586 | |
| 8 | 3309 | |
| 9 | 3168 | |
| 10 | 3424 |
| Value | Count | Frequency (%) |
| 567 | 12 | |
| 565 | 18 | |
| 563 | 17 | |
| 561 | 18 | |
| 558 | 9 | < 0.1% |
| 555 | 25 | |
| 553 | 21 | |
| 545 | 28 | |
| 540 | 21 | |
| 536 | 20 |
delivered_orders
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 504 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 17341 |
| Missing (%) | 3.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.9504483 |
| Minimum | 1 |
|---|---|
| Maximum | 562 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 36 |
| median | 81 |
| Q3 | 146 |
| 95-th percentile | 288 |
| Maximum | 562 |
| Range | 561 |
| Interquartile range (IQR) | 110 |
Descriptive statistics
| Standard deviation | 89.63964602 |
|---|---|
| Coefficient of variation (CV) | 0.8623305383 |
| Kurtosis | 2.117421984 |
| Mean | 103.9504483 |
| Median Absolute Deviation (MAD) | 52 |
| Skewness | 1.389351151 |
| Sum | 44975097 |
| Variance | 8035.266138 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 3798 | 0.8% |
| 4 | 3698 | 0.8% |
| 5 | 3697 | 0.8% |
| 7 | 3645 | 0.8% |
| 3 | 3528 | 0.8% |
| 2 | 3525 | 0.8% |
| 10 | 3403 | 0.8% |
| 8 | 3322 | 0.7% |
| 13 | 3228 | 0.7% |
| 20 | 3207 | 0.7% |
| Other values (494) | 397608 | |
| (Missing) | 17341 | 3.9% |
| Value | Count | Frequency (%) |
| 1 | 2949 | |
| 2 | 3525 | |
| 3 | 3528 | |
| 4 | 3698 | |
| 5 | 3697 | |
| 6 | 3798 | |
| 7 | 3645 | |
| 8 | 3322 | |
| 9 | 3180 | |
| 10 | 3403 |
| Value | Count | Frequency (%) |
| 562 | 12 | |
| 560 | 18 | |
| 559 | 17 | |
| 557 | 18 | |
| 553 | 9 | < 0.1% |
| 550 | 25 | |
| 548 | 21 | |
| 540 | 28 | |
| 535 | 21 | |
| 531 | 20 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 0 | |
|---|---|
| 1 | 5218 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 444782 | |
| 1 | 5218 | 1.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 444782 | |
| 1 | 5218 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 17341 |
| Missing (%) | 3.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7641653126 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 232686 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.066473491 |
|---|---|
| Coefficient of variation (CV) | 1.395605732 |
| Kurtosis | 4.67331547 |
| Mean | 0.7641653126 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.848054475 |
| Sum | 330623 |
| Variance | 1.137365706 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 232686 | |
| 1 | 118103 | |
| 2 | 50582 | 11.2% |
| 3 | 20011 | 4.4% |
| 4 | 7733 | 1.7% |
| 5 | 1851 | 0.4% |
| 6 | 932 | 0.2% |
| 7 | 600 | 0.1% |
| 8 | 105 | < 0.1% |
| 9 | 56 | < 0.1% |
| (Missing) | 17341 | 3.9% |
| Value | Count | Frequency (%) |
| 0 | 232686 | |
| 1 | 118103 | |
| 2 | 50582 | 11.2% |
| 3 | 20011 | 4.4% |
| 4 | 7733 | 1.7% |
| 5 | 1851 | 0.4% |
| 6 | 932 | 0.2% |
| 7 | 600 | 0.1% |
| 8 | 105 | < 0.1% |
| 9 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 56 | < 0.1% |
| 8 | 105 | < 0.1% |
| 7 | 600 | 0.1% |
| 6 | 932 | 0.2% |
| 5 | 1851 | 0.4% |
| 4 | 7733 | 1.7% |
| 3 | 20011 | 4.4% |
| 2 | 50582 | 11.2% |
| 1 | 118103 | |
| 0 | 232686 |
| Distinct | 2887 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 53 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 853.6406643 |
| Minimum | 0 |
|---|---|
| Maximum | 30469 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50 |
| Q1 | 165 |
| median | 396 |
| Q3 | 948 |
| 95-th percentile | 3013 |
| Maximum | 30469 |
| Range | 30469 |
| Interquartile range (IQR) | 783 |
Descriptive statistics
| Standard deviation | 1502.976162 |
|---|---|
| Coefficient of variation (CV) | 1.76066608 |
| Kurtosis | 77.96603641 |
| Mean | 853.6406643 |
| Median Absolute Deviation (MAD) | 287 |
| Skewness | 6.756972165 |
| Sum | 384093056 |
| Variance | 2258937.343 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 1609 | 0.4% |
| 51 | 1230 | 0.3% |
| 290 | 1201 | 0.3% |
| 130 | 1170 | 0.3% |
| 166 | 1162 | 0.3% |
| 228 | 1161 | 0.3% |
| 99 | 1104 | 0.2% |
| 84 | 1091 | 0.2% |
| 57 | 1086 | 0.2% |
| 106 | 1084 | 0.2% |
| Other values (2877) | 438049 |
| Value | Count | Frequency (%) |
| 0 | 5 | < 0.1% |
| 1 | 172 | |
| 2 | 232 | |
| 3 | 293 | |
| 4 | 280 | |
| 5 | 381 | |
| 6 | 344 | |
| 7 | 428 | |
| 8 | 369 | |
| 9 | 375 |
| Value | Count | Frequency (%) |
| 30469 | 50 | |
| 27972 | 55 | |
| 26810 | 26 | < 0.1% |
| 24933 | 4 | < 0.1% |
| 24022 | 80 | |
| 23626 | 33 | |
| 22581 | 34 | |
| 22033 | 27 | < 0.1% |
| 21995 | 10 | < 0.1% |
| 21938 | 7 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 436256 |
| Missing (%) | 96.9% |
| Memory size | 3.4 MiB |
| auto | |
|---|---|
| manual | 361 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.052532014 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | auto |
|---|---|
| 2nd row | auto |
| 3rd row | auto |
| 4th row | auto |
| 5th row | auto |
Common Values
| Value | Count | Frequency (%) |
| auto | 13383 | 3.0% |
| manual | 361 | 0.1% |
| (Missing) | 436256 |
Length
Pie chart
| Value | Count | Frequency (%) |
| auto | 13383 | |
| manual | 361 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 436247 |
| Missing (%) | 96.9% |
| Memory size | 3.4 MiB |
| Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket | |
|---|---|
| Reassignment Request from SE portal. | |
| Reassign |
Length
| Max length | 76 |
|---|---|
| Median length | 76 |
| Mean length | 54.44921108 |
| Min length | 8 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reassignment Request from SE portal. |
|---|---|
| 2nd row | Reassignment Request from SE portal. |
| 3rd row | Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket |
| 4th row | Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket |
| 5th row | Reassignment Request from SE portal. |
Common Values
| Value | Count | Frequency (%) |
| Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket | 7212 | 1.6% |
| Reassignment Request from SE portal. | 5300 | 1.2% |
| Reassign | 1241 | 0.3% |
| (Missing) | 436247 |
Length
Pie chart
| Value | Count | Frequency (%) |
| reassignment | 12512 | |
| auto | 7212 | |
| basis | 7212 | |
| inaction | 7212 | |
| coreengine.tasks.repush_order_to_aa_bucket | 7212 | |
| request | 5300 | |
| from | 5300 | |
| se | 5300 | |
| portal | 5300 | |
| reassign | 1241 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 436247 |
| Missing (%) | 96.9% |
| Memory size | 3.4 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 13753 | 3.1% |
| (Missing) | 436247 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1.0 | 13753 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
session_time
Real number (ℝ≥0)
| Distinct | 65872 |
|---|---|
| Distinct (%) | 14.8% |
| Missing | 3675 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 220.4747785 |
| Minimum | 0 |
|---|---|
| Maximum | 1298.966667 |
| Zeros | 16 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9.8 |
| Q1 | 84.1 |
| median | 175.55 |
| Q3 | 316.7666667 |
| 95-th percentile | 581.2833333 |
| Maximum | 1298.966667 |
| Range | 1298.966667 |
| Interquartile range (IQR) | 232.6666667 |
Descriptive statistics
| Standard deviation | 176.713853 |
|---|---|
| Coefficient of variation (CV) | 0.8015150494 |
| Kurtosis | 0.3002308299 |
| Mean | 220.4747785 |
| Median Absolute Deviation (MAD) | 104.2 |
| Skewness | 0.986198014 |
| Sum | 98403405.53 |
| Variance | 31227.78585 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.06666666667 | 155 | < 0.1% |
| 0.03333333333 | 144 | < 0.1% |
| 0.1166666667 | 136 | < 0.1% |
| 0.15 | 132 | < 0.1% |
| 0.05 | 129 | < 0.1% |
| 0.08333333333 | 124 | < 0.1% |
| 240 | 120 | < 0.1% |
| 0.1 | 118 | < 0.1% |
| 0.1333333333 | 117 | < 0.1% |
| 0.1666666667 | 117 | < 0.1% |
| Other values (65862) | 445033 | |
| (Missing) | 3675 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 16 | < 0.1% |
| 0.01666666667 | 115 | |
| 0.03333333333 | 144 | |
| 0.05 | 129 | |
| 0.06666666667 | 155 | |
| 0.08333333333 | 124 | |
| 0.1 | 118 | |
| 0.1166666667 | 136 | |
| 0.1333333333 | 117 | |
| 0.15 | 132 |
| Value | Count | Frequency (%) |
| 1298.966667 | 1 | |
| 1294.433333 | 1 | |
| 1250.333333 | 1 | |
| 1183.566667 | 1 | |
| 1141.533333 | 1 | |
| 1096.833333 | 1 | |
| 1076.85 | 1 | |
| 1057.483333 | 1 | |
| 1043.866667 | 1 | |
| 1038.216667 | 1 |
| Distinct | 5176 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 444782 |
| Missing (%) | 98.8% |
| Memory size | 3.4 MiB |
| 2021-01-29 17:02:50 | 2 |
|---|---|
| 2021-01-30 16:10:49 | 2 |
| 2021-01-30 16:51:46 | 2 |
| 2021-02-01 14:44:04 | 2 |
| 2021-02-03 15:16:23 | 2 |
| Other values (5171) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 5134 ? |
|---|---|
| Unique (%) | 98.4% |
Sample
| 1st row | 2021-01-26 04:51:46 |
|---|---|
| 2nd row | 2021-01-26 04:08:50 |
| 3rd row | 2021-01-26 05:45:51 |
| 4th row | 2021-01-26 05:10:15 |
| 5th row | 2021-01-26 04:40:46 |
Common Values
| Value | Count | Frequency (%) |
| 2021-01-29 17:02:50 | 2 | < 0.1% |
| 2021-01-30 16:10:49 | 2 | < 0.1% |
| 2021-01-30 16:51:46 | 2 | < 0.1% |
| 2021-02-01 14:44:04 | 2 | < 0.1% |
| 2021-02-03 15:16:23 | 2 | < 0.1% |
| 2021-01-28 17:27:57 | 2 | < 0.1% |
| 2021-01-30 15:06:39 | 2 | < 0.1% |
| 2021-01-27 16:42:16 | 2 | < 0.1% |
| 2021-01-30 15:47:21 | 2 | < 0.1% |
| 2021-01-30 15:45:22 | 2 | < 0.1% |
| Other values (5166) | 5198 | 1.2% |
| (Missing) | 444782 |
Length
| Value | Count | Frequency (%) |
| 2021-01-30 | 723 | 6.9% |
| 2021-02-05 | 496 | 4.8% |
| 2021-01-28 | 483 | 4.6% |
| 2021-02-03 | 464 | 4.4% |
| 2021-01-29 | 448 | 4.3% |
| 2021-02-04 | 433 | 4.1% |
| 2021-02-02 | 428 | 4.1% |
| 2021-01-27 | 427 | 4.1% |
| 2021-01-26 | 421 | 4.0% |
| 2021-01-31 | 394 | 3.8% |
| Other values (4820) | 5719 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| order_time | order_id | order_date | allot_time | accept_time | pickup_time | delivered_time | rider_id | first_mile_distance | last_mile_distance | alloted_orders | delivered_orders | cancelled | undelivered_orders | lifetime_order_count | reassignment_method | reassignment_reason | reassigned_order | session_time | cancelled_time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-01-26 02:21:35 | 556753 | 2021-01-26 00:00:00 | 2021-01-26 02:21:59 | 2021-01-26 02:22:08 | 2021-01-26 02:32:51 | 2021-01-26 02:49:47 | 11696 | 1.566600 | 2.65 | 46.0 | 46.0 | 0 | 0.0 | 621.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 2021-01-26 02:33:16 | 556754 | 2021-01-26 00:00:00 | 2021-01-26 02:33:57 | 2021-01-26 02:34:45 | 2021-01-26 02:50:25 | 2021-01-26 03:11:15 | 18117 | 2.520700 | 2.76 | 8.0 | 8.0 | 0 | 0.0 | 105.0 | NaN | NaN | NaN | 3.266667 | NaN |
| 2 | 2021-01-26 02:39:49 | 556755 | 2021-01-26 00:00:00 | 2021-01-26 02:39:57 | 2021-01-26 02:40:13 | 2021-01-26 02:56:00 | 2021-01-26 03:12:46 | 18623 | 2.207400 | 4.80 | 1.0 | 1.0 | 0 | 0.0 | 66.0 | NaN | NaN | NaN | 9.816667 | NaN |
| 3 | 2021-01-26 02:47:53 | 556756 | 2021-01-26 00:00:00 | 2021-01-26 02:48:25 | 2021-01-26 02:49:06 | 2021-01-26 03:21:51 | 2021-01-26 03:41:05 | 15945 | 2.189400 | 6.38 | 1.0 | 1.0 | 0 | 0.0 | 127.0 | NaN | NaN | NaN | 17.533333 | NaN |
| 4 | 2021-01-26 03:06:30 | 556757 | 2021-01-26 00:00:00 | 2021-01-26 03:07:21 | 2021-01-26 03:07:57 | 2021-01-26 03:31:38 | 2021-01-26 04:00:15 | 17589 | 2.787000 | 4.01 | 34.0 | 34.0 | 0 | 0.0 | 84.0 | NaN | NaN | NaN | 1.350000 | NaN |
| 5 | 2021-01-26 03:07:16 | 556758 | 2021-01-26 00:00:00 | 2021-01-26 03:12:14 | 2021-01-26 03:12:27 | 2021-01-26 03:25:36 | 2021-01-26 03:45:51 | 1469 | 2.481800 | 5.18 | 296.0 | 294.0 | 0 | 2.0 | 1506.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 2021-01-26 03:10:50 | 556759 | 2021-01-26 00:00:00 | 2021-01-26 03:11:18 | 2021-01-26 03:12:05 | 2021-01-26 03:19:31 | 2021-01-26 03:26:04 | 8851 | 2.809100 | 3.40 | 45.0 | 45.0 | 0 | 0.0 | 1460.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 2021-01-26 03:14:10 | 556760 | 2021-01-26 00:00:00 | 2021-01-26 03:14:38 | 2021-01-26 03:14:44 | 2021-01-26 03:33:53 | 2021-01-26 03:42:38 | 8493 | 0.025681 | 0.16 | 54.0 | 53.0 | 0 | 1.0 | 270.0 | NaN | NaN | NaN | 44.166667 | NaN |
| 8 | 2021-01-26 03:14:20 | 556761 | 2021-01-26 00:00:00 | 2021-01-26 03:14:50 | 2021-01-26 03:15:14 | 2021-01-26 04:00:02 | 2021-01-26 04:13:31 | 11543 | 2.444200 | 2.86 | 29.0 | 29.0 | 0 | 0.0 | 955.0 | NaN | NaN | NaN | 2.500000 | NaN |
| 9 | 2021-01-26 03:15:18 | 556762 | 2021-01-26 00:00:00 | 2021-01-26 03:21:27 | 2021-01-26 03:22:04 | 2021-01-26 04:14:56 | 2021-01-26 04:38:39 | 21037 | 2.878600 | 2.61 | NaN | NaN | 0 | NaN | 1.0 | auto | Reassignment Request from SE portal. | 1.0 | NaN | NaN |
Last rows
| order_time | order_id | order_date | allot_time | accept_time | pickup_time | delivered_time | rider_id | first_mile_distance | last_mile_distance | alloted_orders | delivered_orders | cancelled | undelivered_orders | lifetime_order_count | reassignment_method | reassignment_reason | reassigned_order | session_time | cancelled_time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 449990 | 2021-02-06 10:03:00 | 130221 | 2021-02-06 00:00:00 | 2021-02-06 10:03:01 | 2021-02-06 10:04:03 | 2021-02-06 10:07:44 | 2021-02-06 10:15:03 | 3617 | 2.1965 | 1.24 | 22.0 | 22.0 | 0 | 0.0 | 34.0 | NaN | NaN | NaN | 376.416667 | NaN |
| 449991 | 2021-02-06 10:03:01 | 130222 | 2021-02-06 00:00:00 | 2021-02-06 10:04:30 | 2021-02-06 10:06:04 | 2021-02-06 10:26:23 | 2021-02-06 10:36:09 | 773 | 1.4707 | 1.12 | 147.0 | 146.0 | 0 | 1.0 | 773.0 | NaN | NaN | NaN | 268.166667 | NaN |
| 449992 | 2021-02-06 10:03:06 | 130223 | 2021-02-06 00:00:00 | 2021-02-06 10:03:47 | 2021-02-06 10:04:07 | 2021-02-06 10:15:01 | 2021-02-06 10:26:06 | 1407 | 0.3007 | 1.26 | 265.0 | 264.0 | 0 | 1.0 | 477.0 | NaN | NaN | NaN | 209.266667 | NaN |
| 449993 | 2021-02-06 10:03:11 | 130224 | 2021-02-06 00:00:00 | 2021-02-06 10:03:12 | 2021-02-06 10:03:35 | 2021-02-06 10:15:43 | 2021-02-06 10:25:14 | 745 | 2.7013 | 3.72 | 200.0 | 200.0 | 0 | 0.0 | 290.0 | NaN | NaN | NaN | 229.250000 | NaN |
| 449994 | 2021-02-06 10:03:14 | 130225 | 2021-02-06 00:00:00 | 2021-02-06 10:03:23 | 2021-02-06 10:03:43 | 2021-02-06 10:15:36 | 2021-02-06 10:34:10 | 7823 | 1.7916 | 2.60 | 202.0 | 201.0 | 0 | 1.0 | 1426.0 | NaN | NaN | NaN | 273.233333 | NaN |
| 449995 | 2021-02-06 10:03:16 | 130226 | 2021-02-06 00:00:00 | 2021-02-06 10:03:44 | 2021-02-06 10:04:14 | 2021-02-06 10:27:29 | 2021-02-06 10:44:08 | 1006 | 0.5789 | 0.19 | 4.0 | 4.0 | 0 | 0.0 | 127.0 | NaN | NaN | NaN | 369.516667 | NaN |
| 449996 | 2021-02-06 10:03:17 | 130227 | 2021-02-06 00:00:00 | 2021-02-06 10:03:18 | 2021-02-06 10:04:34 | 2021-02-06 10:22:17 | 2021-02-06 10:31:43 | 279 | 1.9863 | 1.19 | 81.0 | 81.0 | 0 | 0.0 | 105.0 | NaN | NaN | NaN | 239.133333 | NaN |
| 449997 | 2021-02-06 10:03:18 | 130228 | 2021-02-06 00:00:00 | 2021-02-06 10:04:06 | 2021-02-06 10:04:39 | 2021-02-06 10:19:06 | 2021-02-06 10:26:56 | 3161 | 1.5944 | 1.61 | 28.0 | 28.0 | 0 | 0.0 | 1488.0 | NaN | NaN | NaN | 204.150000 | NaN |
| 449998 | 2021-02-06 10:03:19 | 130229 | 2021-02-06 00:00:00 | 2021-02-06 10:03:19 | 2021-02-06 10:05:41 | 2021-02-06 10:20:39 | 2021-02-06 10:30:41 | 9396 | 2.8939 | 4.68 | 72.0 | 72.0 | 0 | 0.0 | 105.0 | NaN | NaN | NaN | 65.583333 | NaN |
| 449999 | 2021-02-06 10:03:24 | 130230 | 2021-02-06 00:00:00 | 2021-02-06 10:03:45 | 2021-02-06 10:05:14 | 2021-02-06 10:13:26 | 2021-02-06 10:19:41 | 2078 | 1.8925 | 0.09 | 30.0 | 30.0 | 0 | 0.0 | 108.0 | NaN | NaN | NaN | 212.000000 | NaN |